UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '80IFyu9Ra/ePurJhoIghH0npzqN8+mBvvfFEk8LKPZ8='
WHERE
key_id = 'd077c1bc201367d086f8c0d20a132bfec69945b1f3333773b95250f6583f7d46'
AND (
token = '80IFyu9Ra/ePurJhoIghH0npzqN8+mBvvfFEk8LKPZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)