UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Is8zp25qkCn7dy9aKpNHcz0S98JzhLNbndQXF74EfE='
WHERE
key_id = '497f23861c07f525a379912b44ff17147e12c48a16357efc6c53db016dbcd31d'
AND (
token = '9Is8zp25qkCn7dy9aKpNHcz0S98JzhLNbndQXF74EfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)