UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KDD5XZzMjxYLqr4DHdoFOUAhZIKy2QpaT2xkxZPmBxw='
WHERE
key_id = '4a9970d7832f010069df32f77695be395bdf5cd1a156c4a38675b3e5bae98bfe'
AND (
token = 'KDD5XZzMjxYLqr4DHdoFOUAhZIKy2QpaT2xkxZPmBxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)