UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p3y4d5q8Mo4R8CcIw6COiElmymc1hTFQs+hYe7DnDZ8='
WHERE
key_id = 'bba744e1d4a2d20a2cd8ef1d75cf7a748a8113f5d7aef5f10a46326656d9d008'
AND (
token = 'p3y4d5q8Mo4R8CcIw6COiElmymc1hTFQs+hYe7DnDZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)