UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kUgV0UjHBIR5okkTlpRr5EE/aSpYORzNfi47VOeHoDY='
WHERE
key_id = 'eb45caaba389ade95d9e2a6d76f10dbf0e531055febedf6a4fd8a05019e9b357'
AND (
token = 'kUgV0UjHBIR5okkTlpRr5EE/aSpYORzNfi47VOeHoDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)