UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RgcxTsPbN1amXtQ+ioFz+pC8FOtwDOMlDZD6yW6+q/U='
WHERE
key_id = 'ac76611cb76088901b20a953b0f2f3fec4543e59e1a501dedde13c747ced6bf2'
AND (
token = 'RgcxTsPbN1amXtQ+ioFz+pC8FOtwDOMlDZD6yW6+q/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)