UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WCIaeV37r/0CIxXYbDgpfXzMKf28un5acVpdF6OHUU8='
WHERE
key_id = '7dd0e6cd5a470c458174a779ddb90060dc110fbb2378a526581ff691071da6d9'
AND (
token = 'WCIaeV37r/0CIxXYbDgpfXzMKf28un5acVpdF6OHUU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)