UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9VmCG1Y2x9RGKSQX0bZ0bDpk1FJFQJ1f2KFB7o3H0qw='
WHERE
key_id = '0c06bbf0a79b8ad989d0983eccbdff6efb18eafbf252ed4d3ab459c4ca4dd069'
AND (
token = '9VmCG1Y2x9RGKSQX0bZ0bDpk1FJFQJ1f2KFB7o3H0qw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)