UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9cLDCJdmNRHt8tmjM5C9jKJOPUKt7m7aTezNNZUPNR8='
WHERE
key_id = '6a1b730bce9d833f432e1aa0e7f0f7f1e32151d16747a79ca07d01b669eca908'
AND (
token = '9cLDCJdmNRHt8tmjM5C9jKJOPUKt7m7aTezNNZUPNR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)