UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hoRruLlYFrI8zYSltLQcRItjaNGghx7p4+1mulE1Ks0='
WHERE
key_id = '1e975ba6df3c6de5cbcb3ffd160b8eff5c0a87bfd3241a53167841bd5f830a50'
AND (
token = 'hoRruLlYFrI8zYSltLQcRItjaNGghx7p4+1mulE1Ks0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)