UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8K147L9JtxwVkFZsAvLYXiCr/GAbcYQyMh9z+OB/6Hw='
WHERE
key_id = '6d653b1f00e50533e835dcacbb13807f082b0fc588fe3b2b053e6d23b3f1fb93'
AND (
token = '8K147L9JtxwVkFZsAvLYXiCr/GAbcYQyMh9z+OB/6Hw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)