UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yKLBMf2zwMUuGdZddfCIplIPgR0dx9Q7k7mVlMVRCUQ='
WHERE
key_id = '77a226abec4e58d36ffe505b158f8c5e2d5badb2681f3c2efdfa86fcdc2012ae'
AND (
token = 'yKLBMf2zwMUuGdZddfCIplIPgR0dx9Q7k7mVlMVRCUQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)