UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '687MavBjEUocLeLGGDNk3CgcSqziO7lGVLIYphwwEZs='
WHERE
key_id = 'b577dce6108911bcfc1c36a2508264c64f17fa643a9a56bc5932497a65d31013'
AND (
token = '687MavBjEUocLeLGGDNk3CgcSqziO7lGVLIYphwwEZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)