UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pIWsEH40drXWU/93VwQAcw7iFS3lDGMS9QD+xAgTXEc='
WHERE
key_id = 'c91dae162185926f2011fe8033a78949a82a976d1008b5baef8f5c15eeca3594'
AND (
token = 'pIWsEH40drXWU/93VwQAcw7iFS3lDGMS9QD+xAgTXEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)