UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oW5olxEUO1/hU+5bKnh9kHnsLMZGFdi84ofhbrc2wTE='
WHERE
key_id = 'b4654025b523b3400ce02d3f0fdb3ff2a2e5e77aa14946cda9ca04e47d0df43d'
AND (
token = 'oW5olxEUO1/hU+5bKnh9kHnsLMZGFdi84ofhbrc2wTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)