UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '43R8bDyZ7n+Qfu15aw8E32arswUiv9F5ls3Kuj5L+r4='
WHERE
key_id = 'd14c61ef36565ac956db55e16640f904ac47700b3b04d401f0607d3dda98a97d'
AND (
token = '43R8bDyZ7n+Qfu15aw8E32arswUiv9F5ls3Kuj5L+r4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)