UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/H4KZisHA6YcACcKBfRjofQ+RYzYy19QgYdLdn8QO7k='
WHERE
key_id = 'a0cf1eabb52e4cb22c0ae562ab7ae7b17511e01092b610e73fd2d757f5554657'
AND (
token = '/H4KZisHA6YcACcKBfRjofQ+RYzYy19QgYdLdn8QO7k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)