UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cZJHEgQZ528kWMbr3Qh4FFirB8jSbXNlKYaJ/bDgRGs='
WHERE
key_id = 'd6591e34e34693508374c1497c5966d3807c1a14ec677da5082d673023d89ef8'
AND (
token = 'cZJHEgQZ528kWMbr3Qh4FFirB8jSbXNlKYaJ/bDgRGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)