UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZJl7coSMXVfMlCJumODld9JrsyZG6DCUJ0iBYjVLZg0='
WHERE
key_id = 'eb98f7df1eb76e7a42468d77bceba3691d31011b37eef68a82d26c70e9f52677'
AND (
token = 'ZJl7coSMXVfMlCJumODld9JrsyZG6DCUJ0iBYjVLZg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)