UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NUlZxF56fA+JACSTM1/nJewgtykU777r3BxFqzj0Yw4='
WHERE
key_id = '7a9a5b12f7789cb3a670276cc3b0aa7c0ec1864d2904d46caa26aee100a09ec5'
AND (
token = 'NUlZxF56fA+JACSTM1/nJewgtykU777r3BxFqzj0Yw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)