UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yjr8KDBFq9RG4JC1GuR9GFH9ZWZSWH612dGsHQ2n/g8='
WHERE
key_id = '686379d37a870bacc0e40ae57942841e4ea23331bba4ad22204765028b925628'
AND (
token = 'Yjr8KDBFq9RG4JC1GuR9GFH9ZWZSWH612dGsHQ2n/g8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)