UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G7L+BfWJiE17DJOazLIdC4zL8TnYTvdh0ag4Oa90oEE='
WHERE
key_id = 'f005f41c5079c5bfd7bd7f589209eec32d11170bf166587f3e1ed4d4125b3ee1'
AND (
token = 'G7L+BfWJiE17DJOazLIdC4zL8TnYTvdh0ag4Oa90oEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)