UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+2jEvc8xv95ECz7+0yJYun2pxEVT/axYBjMGF8iAoU8='
WHERE
key_id = '8630e1fbb740dc909a478828a0ca03f7d06167f9e4a5eb2d95b3a99cda553bd2'
AND (
token = '+2jEvc8xv95ECz7+0yJYun2pxEVT/axYBjMGF8iAoU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)