UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8xoZ3tusp8tY9jDhLsV33t8C9pjuIU5MmC3Dnvfjchw='
WHERE
key_id = 'c5e66d3ad5954c995020975fe1d5bcffcf3d41e809771f424bd9e4030be07b0c'
AND (
token = '8xoZ3tusp8tY9jDhLsV33t8C9pjuIU5MmC3Dnvfjchw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)