UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W810S7HfjR7zIrTIt6ge8762ZoGGa/1/K0HsO8pZCTc='
WHERE
key_id = '4e5d938e9de94573375a62165e6b4fd595683a7498b1d828dcf77ded3e16a754'
AND (
token = 'W810S7HfjR7zIrTIt6ge8762ZoGGa/1/K0HsO8pZCTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)