UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HF8SUsH+yW1ETpNE0PcEsXzqfRvHEgHwfYqvAuNEtoA='
WHERE
key_id = '24ad5fd49c5aaa1fedf7011a60b8ac3f90d5ad38af4bf853b3741d0b1081adef'
AND (
token = 'HF8SUsH+yW1ETpNE0PcEsXzqfRvHEgHwfYqvAuNEtoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)