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