UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Rp7nmL8ZwIvRNmoaCkDfs3DAT90UaG5htFZs61U1cA='
WHERE
key_id = '0bab5952f3d48447aeeb0b91ae9935820831cd1f1d3f3020f15e8fa01b8d2b19'
AND (
token = '7Rp7nmL8ZwIvRNmoaCkDfs3DAT90UaG5htFZs61U1cA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)